use master
go
if exists(select * from sys.databases where name='useinfoDB')
drop database useinfoDB
go
create database useinfoDB
on
(
name='useinfoDB_mdf',
filename="D:\useinfoDB_mdf.mdf",
size=5mb
)
log on
(
name='useinfoDB_ldf',
filename="D:\useinfoDB_ldf.ldf",
size=5mb
)
go
use useinfoDB
go
create table useandpwd
(
AdminID int primary key identity(1,1),
AdminName nvarchar(20) not null,
Adminpass nvarchar(20) not null,
AdminRole int not null,
AdminStatus int not null
)
go
insert into useandpwd(AdminName,Adminpass,AdminRole,AdminStatus) values ('admin','admin1',1,1)
